Closed

SQL data2 connection problem

when connecting to my site I get

Provider error '80040e21'

Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done.

/SFpool3/includes/[url removed, login to view], line 527

the common file code is

Opens the database connection (global variable 'DbConn').

'--------------------------------------------------------------------------

sub OpenDb()

dim isPhysicalPath

dim dbDir

set DbConn = [url removed, login to view]("[url removed, login to view]" )

line527-----errorr [url removed, login to view] DATABASE_CONNECTION_STRING

'If the path to the database is not physical, map it.

isPhysicalPath = false

if Len(DATABASE_FILE_PATH) >= 3 then

if Mid(DATABASE_FILE_PATH, 2, 2) = ":\" then

isPhysicalPath = true

end if

end if

if not isPhysicalPath then

dbDir = [url removed, login to view](DATABASE_FILE_PATH)

else

dbDir = DATABASE_FILE_PATH

end if

if USE_ACCESS_ODBC_DRIVER then

[url removed, login to view] "DBQ="& dbDir & ";Driver={Microsoft Access Driver (*.mdb)}"

else

[url removed, login to view] "Data Source=" & dbDir & ";Provider=Microsoft.Jet.OLEDB.4.0;"

end if

end sub

the config file code is

'Location of the database.

const DATABASE_FILE_PATH = "./data/[url removed, login to view]"

'Database connection string (Can be Access or SQL Server).

'const DATABASE_CONNECTION_STRING = "Data Source=E:\web\survival\SFpool3\data\[url removed, login to view]; Provider=Microsoft.Jet.OLEDB.4.0;"

const DATABASE_CONNECTION_STRING = "Provider=SQLOLEDB;Data Source=tcp:[url removed, login to view];Initial Catalog=DB_26_nfl;User ID=DB_26 _nfl_user;Password=xxxxxxxx;Integrated Security=false;"

on the web the description of the error says that it is a data error, I used sql studio management to create the tables and there was no errors.

I attached the query that i ran to create the tables

Skills: Data Processing, SQL

See more: connection problem data2, tcp global, string problem, sql server open source, open source sql, sql create database, map string, jet sql, common string, common query, sql microsoft access, microsoft access sql, survival, sql microsoft, sql data, sql code, sql access, nfl, mdb, len, data source sql, access sql, asp sql connection, connecting server, connection string access

About the Employer:
( 0 reviews ) St-leonard, Canada

Project ID: #1151103

6 freelancers are bidding on average $53 for this job

ruimaxwell

Thank you.

$45 USD in 1 day
(11 Reviews)
4.5
dracco

expert here ready to help you, I'm ready to start now. Dracco.

$40 USD in 0 days
(6 Reviews)
3.5
hcy0212

Hi abt888 I looked at your code, and need to ask you few additional questions. Please check your PMB. Thanks, John

$40 USD in 1 day
(5 Reviews)
3.4
edgesoftpro

Hi, Ready to fix it. Regards, EdgesoftPro

$50 USD in 0 days
(0 Reviews)
0.0
smbakhtiar

I am interested.

$60 USD in 1 day
(0 Reviews)
0.0
swarmuz

Can sort it out.

$40 USD in 1 day
(0 Reviews)
0.0
AhmedEj

hi, i can do this. i have 6 years working experience in this field. please contact.

$80 USD in 1 day
(0 Reviews)
0.0