Search DaniWeb - dsn

Re: dsn on other computer of the same lan 14 Years Ago by jinnie_gia … plan. under control panel, ODBC, create a new DSN (data service Name) point to the access database, …rec As ADODB.Recordset 'under control panel_odbc create a DSn called Jinnie_test. point it to mdb file and enter…Connection Set rec = New ADODB.Recordset conn.Open "Dsn=test" rec.Open ("select * from staff"… Re: dsn on other computer of the same lan 14 Years Ago by sal21 …adopt this plan. under control panel, ODBC, create a new DSN (data service Name) point to the access database, enter …Connection, rec As ADODB.Recordset 'under control panel_odbc create a DSn called Jinnie_test. point it to mdb file and enter user…] Tks...for sugestion i know this way. But the dsn is on other computer not is located in the pc… DSN in Windows 7 13 Years Ago by jhai_salvador … Optional xPassword As String) 'Creating the DSN #If Win32 Then Dim intRet As Long… & Chr$(0) strAttributes = strAttributes & "DSN=" & xDSN & Chr$(0) strAttributes = …= SQLConfigDataSource(vbAPINull, ODBC_ADD_SYS_DSN, _ strDriver, strAttributes) ' DSN created End Sub [/CODE] Heres how to use it… DSN connection 16 Years Ago by chicago1985 For the past 5 years I been using DSN connections to connect to Oracle in my Cold Fusion. Is… way to connect in Cold Fusion MX 7 without using DSN? <CFQUERY NAME="query_name" DATASOURCE="db_name&…</CFQUERY> Maybe instead of System admins creating DSN, I can create the DSN in a Cold Fusion template? Please advise. dsn on other computer of the same lan 14 Years Ago by sal21 … pc with the same code on the dsn on original pc where reside the dsn? Tks for all and sorry for my… ADODB.Connection Set rec = New ADODB.Recordset conn.Open "Dsn=test" rec.Open ("select * from staff"), conn… note: i know the ip od pc where is the dsn Re: dsn on other computer of the same lan 14 Years Ago by vb5prgrmr … MySQL drivers on the other machine. 2nd, create the ODBC DSN on the other machine to point to your instance of… cannot have a program on another computer access your ODBC DSN. It needs to be created on the other computer. Good… dsn with vb.net 16 Years Ago by ashok_misra21 … to use database connection in .net in sql way using dsn, without using provider like what i m write in vb… new adodb.connection dim sql as string con.open("dsn=test") dim rs as new adodb.recordset sql="… DSN using ODBC Driver for Oracle doesn't remember password 16 Years Ago by BlackSwan Hi everyone, I have a third-party application which uses DSN (in this case, only system and user DSNs) to setup … Re: DSN using ODBC Driver for Oracle doesn't remember password 16 Years Ago by jwenting If there's no field to enter it in the DSN properties dialog, there isn't. If there is, there is. dsn less connection using ms data acess in dot net 13 Years Ago by coolla can anyone help as how to use dsn less connection(c#) using ms data acess in dot net. also i need to know where to use that code .. i need my window application which i have created using c # to make it run on different servers. Re: File DSN Mysql 11 Years Ago by pritaeas DSN for MySQL looks like this: mysql://user:pass@localhost:port/my_db Error Received When Trying To Create DSN From The Command Line 16 Years Ago by CoMpUtErGoD20XX … deployment. Everything is done except for getting the DSN created which is causing me major problems. We… /a {CONFIGSYSDSN "Oracle in OraClient10g_home1" "DSN=CCR|Description=CCR_data|SERVER=BWB|Database=CCR"} ---------------------- As… double click the script and it adds the DSN fine. Thanks so much for your help in… ASP DSN-Less Connection Issues 11 Years Ago by jonnahealey …to the forums. My issue relates to ASP and a DSN-less connection. I have a website, which was built quite… a while ago using DSN connections to an Access database, which ran on a 2003…=Server.CreateObject("ADODB.Recordset") objRec2.Open sql2, "dsn=database"` Which I then changed to this: `Get the… Re: Crystal Report- Multiple DSN 13 Years Ago by Victoryy … database name is changes so the DSN name is also change No need to change DSN name.[/QUOTE] first the name of… database is AccountDemo at that time the name of dsn is dsnAccDemo then i have created the new copy of… database.... what should i do now?? can we use one dsn for multiple databases.... thanks in advance. Connect VB6 with SQL Server 2k by DSN and DBQ, logging screen, dbase loc, uid and pwd 16 Years Ago by ayan.mukherjee … Server 2000 as a database. I need to develop a DSN for my application, which I have successfully done from the… ODBC tab. The DSN name is "Employee". My SQL Server 2000's….e. App.Path has to be supplied along with the DSN name and DBQ Name is also required to provide as… Crystal Report- Multiple DSN 13 Years Ago by Victoryy Hi Firstly i have designed crystal reports by giving a DSN name at the designing time.. but now the database name is changes so the DSN name is also change How can i give the dsn name of the currently used database in asp.net. Thanks in advance. File DSN Mysql 11 Years Ago by fdkallday_1 … to connect my database from mysql to dataenvironment using file dsn like i did with access. the reason i used… dsn because i need my .exe and database to be portable. … project is running with 3 files - project.exe - database.mdb - .dsn can anyone please help me. i havent tried using mysql… Re: Crystal Report- Multiple DSN 13 Years Ago by kvprajapati >but now the database name is changes so the DSN name is also change No need to change DSN name. Create DSN at Run time 15 Years Ago by Ravi Kant Hi Friends ! I want to create DSN automatically with common dialog to choose database. I don't want user have to go to control pannel \ Administrative tools \ ODBC Manager for create DSN. I am using MS Access as My Database. How can i do it ? Plz help . vista DSN name oracle odbc driver missing 14 Years Ago by jeeva.gururaj i'm using jsp to connect to oracle database. I've installed oracle 10g .when i try to set a dsn name in control panel-administrative tools-Data sources(odbc)-system dsn-add-only sql native client and sql server are availabe. OS: vista home premium Please help me. Re: VB to connect other pc access DSN 14 Years Ago by vb5prgrmr Wrong, each computer that connects to a server/service like SQL, Oracle, etc, needs an ODBC DSN if you are not using ADO's DSN Less capability. Having a ODBC DSN on just the server will not work... Good Luck Re: Crystal Report- Multiple DSN 13 Years Ago by kvprajapati Here is a link - How to set [URL="http://www.codeguru.com/forum/showthread.php?t=489668"]DSN[/URL] programatically? create DSN of odbc for MS Access 9 Years Ago by moaz.amin.37 … `java.lang.ClassNotFoundException: sun.jdbc.odbc.JdbcOdbcDriver` i already create DSN but but it stil show this error i do not… i do My jdk is 64 bit and i create DSN of odbc 32 bit is any problem is here that… Create ODBC DSN to InstallShield 9 Years Ago by sergio_pb … have database bd_final_v1, but now i need to create a DSN OBDC linkage for other users. I create a program for… work. Someone can help me? 1. First create a sample DSN using ODBC. 2. Now click run and enter Regedit through… Re: Create DSN at Run time 15 Years Ago by jonc I believe it stores DSN information in the registry, so you could try doing it that way. I don't know how you would do this (never done it before myself) - I'm just offering an idea on how to do what you are looking for. Re: VB to connect other pc access DSN 14 Years Ago by vb5prgrmr An ODBC DSN (Open DataBase Connectivity Data Source Name) must be created on each computer that will use the end result of the Visual Basic 6.0 design process. Meaning you create the exe and the installable package and install the program on the machine and then create the ODBC DSN... Good Luck Re: Create ODBC DSN to InstallShield 9 Years Ago by cgeier … suggest you be more specific. I don't believe that DSN's are used very widely anymore. It is preferrable to… creating dsn 19 Years Ago by grajeshmsc I needs to create DSN on ODBC thru java ...[i'm using oracle 8i] So please help me out a perfect solution... Regards GR Creating a DSN from within vb 15 Years Ago by rajeshkhanna_in … of Question Papers for Various Exams. This software uses a DSN connection to a ACCESS database. While I was developing software… Re: Creating a DSN from within vb 15 Years Ago by K.Vanlalliana Hi, If you are makeing connection using DSN/ODBC, you will have to set it manually for every …