Duplicate website, from SQL Server 2000 to 2005
I have one directory website which is up and running and using the sql server 2000 database thru Godaddy. I recently made a duplicate of this website as I plan to start a new directory. The only difference will be that Godaddy has assigned it a sql server 2005 database. In respect to the connection string, is there a difference to how it should be typed? Im currently getting an error and not able to connect to the sql server 2005. This is my connection string -
Application("DSN") = "Provider=SQLOLEDB.1;Password=XXX;Persist Security Info=True;User ID=XXXXX;Initial Catalog=AbcHomeInspector;Data Source=XXXXXXXXXXXXX"
I basically switched out/updated the Password, User ID, etc information and left all else as is. Can someone please help me with this. These are the only two lines of code which are different from website to website, as per the different user name, password, Data Sourse,etc...
Thank you very much,
It should be working with the same connection string from 2000 -> 2005.
What is the error message? Please update your question and include the error message!
FYI Released: Microsoft OLE DB Driver for SQL Server
Hi ADO is undeprecated. There is a new release of ADODB driver for SQL Server. It supports SQL Server from 2012 to 2017 and Azure also. Follow the link: https://blogs.msdn.microsoft.com/sqlnativeclient/2018/03/30/released-microsoft-ole-db-driver-for-sql-server/0 votes1 answerJosé Mª Fueyo7 days ago
Server and Localhost database access problem
Hi. I have an asp.net web site on our internal server. And I have a program that is using localhost sql server database. I want to access these localhost database when I open the web page on my computer.0 votes0 answersSüleyman İbrahimbaş1 month ago
Logged in windows user is different than a domain user has SQL access
I have to use fixed Domain user in connection string to connect to SQL server. But the logged user for windows is different. Is there any solution . this is requirement of our project. Please help .0 votes0 answersAsmita Kudale1 month ago
ASP connection to .xls
I am trying to insert excel data into an access database. The code below works perfectly for me even though it gives me access denied after successful upload. <% Set cn = CreateObject("ADODB.Connection")0 votes0 answersWisdom Deku2 months ago
Error connection to SQL Server 2014 via dotnet
I'm new into using Automations and dotnet, so i'm trying to learn (if I don't explain correct ). I'm trying to connect from NAV 2016 to an external SQL Server 2014 to read and post data to this.0 votes2 answersMads Morre6 months ago
vibratory bowl feeder
we provide quality viratory bowl feeders and we have many other machine which will give you idea, we are vibratory bowl feeder manufacture in pune and provide best services.0 votes1 answervibratory bowl feeder6 months ago
sql server tcp connection timed out
i have installed SQL server 2016 on a VPS that is running Win server 2016, i have enabled TCP/IC conectivity and made inbound rules for ports 1433,1434 and SQLSERV.exe.0 votes2 answersReza Deabae6 months ago
Study Guides or Test Sample for the position of Admin asst?
Study Guides or Test Sample for the position of Admin asst? I’m testing for administrative Asst in the civil service sector.So I’ve to take a test to MS Word and Excel. and it’s practical to test my abilities.0 votes5 answersLiza John6 months ago
Connect to Oracle using SqlSriverConnect
Fingers crossed someone can help. I am looking for a connection string to use in MS Access 2010 to connect to Oracle using SqlSriverConnect so that I can specify SQLDRIVERNOPROMPT. My attempts to format a connection string to date have been unsuccessful. Please accept my thanks in advance.0 votes3 answersDes Davies6 months ago
Connection String for a Hosted Database (Domain/Web hosting Provider) --- Windows Forms
I have domain name, and host account with a service provider. I want to host a sql server database through the service provider. I'm developing a windows forms application that I want to access this database. Whats the way to go with this situation?0 votes2 answersOageng Escobar Baruti7 months ago
- Load more posts